package com.ophiux.member.mapper;

import org.apache.ibatis.annotations.Select;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ophiux.member.model.entity.MemberMailAddress;

public interface MemberMailAddressMapper extends BaseMapper<MemberMailAddress> {
	
	/**
	 * 查询会员的地址数量
	 * @param id
	 * @return
	 */
	@Select("select count(id) from member_mail_address where member_id=#{id}")
	int getAddressCountByMemberId(Integer id);

}
